-- created by kumiler
-- on 2023/3/14 16:07
-- DESC
CREATE TABLE jms_dim.dim_sys_agency_district_city_base (
  `id` bigint(20) NULL COMMENT "id",
  `name` varchar(65533) NULL COMMENT "区域(片区)名称",
  `code` varchar(65533) NULL COMMENT "区域(片区)编码",
  `network_id` varchar(65533) NULL COMMENT "虚拟代理区ID",
  `network_name` varchar(65533) NULL COMMENT "虚拟代理区名称",
  `network_code` varchar(65533) NULL COMMENT "虚拟代理区code",
  `is_enable` varchar(65533) NULL COMMENT "是否启用:1启用,2不启用",
  `is_delete` varchar(65533) NULL COMMENT "是否删除:1未删除,2已删除",
  `create_by` varchar(65533) NULL COMMENT "创建人ID",
  `update_by` varchar(65533) NULL COMMENT "最后更新人ID",
  `create_by_name` varchar(65533) NULL COMMENT "创建人名称",
  `update_by_name` varchar(65533) NULL COMMENT "最后修改人名称",
  `create_time` varchar(65533) NULL COMMENT "创建时间",
  `update_time` varchar(65533) NULL COMMENT "更新时间",
  `city_list` varchar(65533) NULL COMMENT "城市id 列表",
  `city_id` varchar(65533) NULL COMMENT "城市id"
) ENGINE=OLAP
DUPLICATE KEY(`id`, `name`, `code`)
COMMENT "区域(片区)-城市维护表"
DISTRIBUTED BY HASH(`id`) BUCKETS 1
PROPERTIES (
"replication_num" = "3",
"in_memory" = "true",
"storage_format" = "V2"
);